Editing User General

The General tab allows you to set user properties which are:

User name
Set name of the user.

Authentication
Choose to use either Password, External or Global as authentication method.

Password
A local user must specify password to log on to the database.

Password
Set user's password.

Confirm Password
Re-type the user's password here.

Expire Password
Expire the user's password. This setting forces the user or the DBA to change the password before the user can log in to the database.

External
An external user must be authenticated by an external service, such as an operating system or a third-party service.

Global
A global user must be authorized by the enterprise directory service (Oracle Internet Directory).

X.500 Distinguished Name
Enter the X.509 name at the enterprise directory service that identifies this user.

Default Tablespace
Choose the default tablespace for objects that the user creates.

Temporary Tablespace
Choose the tablespace or tablespace group for the user's temporary segments.

Profile
Choose the profile that assign to the user.

Lock account
Lock the user's account and disable access.